package com.banana.manager.forest.dao.chemical;

import com.banana.manager.forest.entity.chemical.DisburseBean;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;

public interface IDisburseDao extends BaseMapper<DisburseBean> {

    @Select("select * from disburse_info join out_info on disburse_id = fk_disburse_id join " +
            "device_info on device_id = fk_device_id WHERE disburse_id = #{id}")
    @ResultMap("disburseMap")
    DisburseBean findOneById(Integer id);
}
